package cn.com.nes.mybatis.agent.templatedesign.mapper;


import cn.com.nes.mybatis.agent.templatedesign.entity.HDevicemodel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *  Mapper 接口
 *
 * @author 
 * @since 2023-09-26
 */
public interface HDevicemodelMapper extends BaseMapper<HDevicemodel> {

public int addHouseDeviceModel(@Param("sbcj")String sbcj,@Param("sbxh_id")String sbxh_id,@Param("devicedesignpath")String devicedesignpath,@Param("devicedesignfilename")String devicedesignfilename,@Param("createUid")Integer createUid,@Param("createTime")String createTime,@Param("createName")String createName);

public int updateHouseDeviceModel(@Param("id")int id,@Param("sblx_id")String sblx_id,@Param("sbcj")String sbcj,@Param("sbxh_id")String sbxh_id,@Param("modifyUid")String modifyUid,@Param("devicedesignfilename")String devicedesignfilename,@Param("devicedesignpath")String devicedesignpath,@Param("createName")String createName);

public int deleteHouseDeviceModelById(@Param("id") int id);
 List<Map<String,Object>> selectSbxh_idAndSbxhname(@Param("sbcj") String sbcj);
public List<Map<String, Object>> selectHouseDeviceModel(@Param("id")Integer id,@Param("sbcj")String sbcj,@Param("sbxh_id")String sbxh_id,@Param("offSet")int offSet,@Param("pagesize")int pagesize);

 int selectAllList();

// List<Map<String,Object>>
 List<Map<String,Object>>selectSbxhIdAndName(HDevicemodel hDevicemodel);


 List<Map<String,Object>> selectSbcjAndSbxh_id(@Param("sbcj") String sbcj,@Param("sbxh_id")String sbxh_id);
}
